{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Worksheet","Old W4 Calculation","New W4 Calculation","Speedtime","OTO Upload","Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":26,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Worksheet","index":0,"n_rows":65,"n_cols":19,"rows_kept":65,"cut":false,"hidden":false,"merged":[[9,1,10,2],[9,5,9,6],[9,3,9,4],[20,1,20,2],[22,1,22,2],[56,4,56,7],[63,5,63,7],[62,4,62,7],[36,4,44,7],[45,4,45,5],[45,6,45,7],[60,1,60,7],[61,4,61,7],[61,1,61,3],[50,1,50,3],[48,1,48,2],[36,1,36,3],[45,1,45,2],[63,2,63,3],[62,1,62,3],[51,4,51,5],[18,1,18,2],[16,1,16,2],[17,1,17,2],[6,5,6,6],[27,9,27,11],[34,7,35,7],[34,9,34,11],[33,9,33,11],[28,9,28,11],[7,9,7,11],[6,9,6,11],[7,5,7,6],[9,9,9,11],[10,9,10,11],[24,9,24,11],[25,9,25,11],[26,9,26,11],[10,5,10,6],[11,5,11,6],[24,4,24,7],[7,3,7,4],[8,5,8,6],[8,3,8,4],[8,1,8,2],[29,9,29,11],[13,9,13,11],[12,9,12,11],[14,9,14,11],[15,9,15,11],[18,9,18,11],[20,9,20,11],[21,9,21,11],[19,9,19,11],[24,1,24,2],[19,1,19,2],[21,1,21,2],[25,1,25,3],[11,3,11,4],[13,1,13,3],[12,1,12,7],[11,9,11,11],[22,9,22,11],[23,9,23,11],[16,9,16,11],[11,1,11,2],[14,1,14,2],[15,1,15,2],[38,9,62,15],[30,9,30,11],[31,9,31,11],[32,9,32,11],[36,9,37,15],[17,9,17,11],[25,4,33,7],[34,4,35,6],[49,1,49,2],[52,6,55,7],[57,4,59,7],[23,1,23,2],[0,9,0,15],[3,9,3,11],[4,9,4,11],[8,9,8,11],[1,3,1,5],[1,9,1,11],[2,9,2,11],[2,5,2,6],[4,5,4,6],[0,1,0,7],[1,1,1,2],[2,1,2,2],[2,3,2,4],[3,3,3,4],[4,3,4,4],[3,1,3,2],[4,1,4,2],[5,9,5,11],[5,1,5,2],[3,5,3,6],[6,1,6,2],[7,1,7,2],[5,3,5,4],[6,3,6,4]]}
[null,"2023 E1 INTERIM PAYROLL WORKSHEET Rev 3/2/23",null,null,null,null,null,null,null,"ADDITIONAL ACCOUNTS"]
[null,"Employee name",null,null,null,null,"Date",null,null,"Account Number",null,null,"Pay Type","Hours","Rate","Lump Sum"]
[null," Address book #",null,null,null,"(M)onthly / (B)i-weekly",null,"B",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(M3<>70,N3*O3,N3*O3*1.5),0)","v":0}]
[null,"Retirement percentage",null,{"$f":"IF(D10=\"S\",4.8%,IF(D10=\"J1\",9%,IF(D10=\"J2\",7%,IF(D10=\"J3\",5%,IF(D10=\"J4\",1%,IF(D10=\"J5\",10%,IF(D10=\"P\",16%,IF(D10=\"T\",9.78%,\"ERROR\"))))))))","v":4.8000000000000001E-2},null,"Old / New W-4",null,"New",null,null,null,null,null,null,null,0,null,null,"Fill(ed) out"]
[null,"Match percentage",null,{"$f":"IF(D10=\"S\",156%,IF(D10=\"J1\",0%,IF(D10=\"J2\",0%,IF(D10=\"J3\",0%,IF(D10=\"J4\",0%,IF(D10=\"J5\",0%,IF(D10=\"P\",100%,IF(D10=\"T\",101%,\"ERROR\"))))))))","v":1.56},null,{"$f":"IF(H4=\"Old\",\"(M)arried / (S)ingle\",\"STATE (M)arried / (S)ingle)\")","v":"STATE (M)arried / (S)ingle)"},null,"S",null,null,null,null,null,null,null,0,null,null,"Required to be filled out"]
[null,{"$f":"IF(H4=\"New\",\"W4 Multiple Job Flag\",\"DO NOT USE\")","v":"W4 Multiple Job Flag"},null,"N",null,null,{"$f":"IF(H4=\"New\",\"(A)Married/(J)Single/(H) HOH\",\"DO NOT USE\")","v":"(A)Married/(J)Single/(H) HOH"},"J",null,null,null,null,null,null,null,0,null,null,"Static or calculated value"]
[null,{"$f":"IF(H4=\"New\",\"W4 Dependent Credit\",\"DO NOT USE\")","v":"W4 Dependent Credit"},null,0,null,{"$f":"IF(H4=\"Old\",\"Exemptions\",\"State Exemptions\")","v":"State Exemptions"},null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"IF(H4=\"New\",\"W4 Other Income\",\"DO NOT USE\")","v":"W4 Other Income"},null,0,null,{"$f":"IF(H4=\"New\",\"W4 Other Deductions\",\"DO NOT USE\")","v":"W4 Other Deductions"},null,0,null,null,null,null,null,null,null,0]
[null,"Retirement (yes or no)",null,"Yes",null,"Over 55 / Use sick payout?",null,"No / No",null,null,null,null,null,null,null,0]
[null," S=State, T=Teacher, P=Patrol Judges : J1=9%, J2=7%, J3=5%, J4=1%, J5=10%",null,"S",null,"Take additional FIT/SIT?",null,"No",null,null,null,null,null,null,null,0]
[null,null,null,null,null,"Additional FIT",null,0,null,null,null,null,null,null,null,0]
[null,"Gross Pay",null,{"$f":"SUM(H15:H24)+SUM(P3:P35)","v":0},null,"Additional SIT",null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Account Number",null,null,"Pay Type","Hours","Rate","Lump Sum",null,null,null,null,null,null,null,0]
[null,null,null,"Regular",1,null,null,{"$f":"IFERROR(IF(E15<>70,F15*G15,F15*G15*1.5),0)","v":0},null,null,null,null,null,null,null,0]
[null,null,null,"Reg Adjust",2,null,{"$f":"IF(B16<>\"\",G$15,)","v":0},{"$f":"IFERROR(IF(E16<>70,F16*G16,F16*G16*1.5),0)","v":0},null,null,null,null,null,null,null,0]
[null,null,null,"Vacation",30,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,"Sick",40,null,0,0,null,null,null,null,null,null,null,0]
[null,null,null,"Holiday",240,null,0,{"$f":"IFERROR(IF(E19<>70,F19*G19,F19*G19*1.5),0)","v":0},null,null,null,null,null,null,null,0]
[null,null,null,"Vac Payout",330,null,0,{"$f":"IFERROR(IF(E20<>70,F20*G20,F20*G20*1.5),0)","v":0},null,null,null,null,null,null,null,0]
[null,null,null,"Sick Payout",320,{"$f":"IF(RIGHT(H9,3)=\"Yes\",IF(H50*0.25>Data!B9,Data!B9,H50*0.25),\"Not applicable\")","v":"Not applicable"},0,{"$f":"IFERROR(IF(E21<>70,F21*G21,F21*G21*1.5),0)","v":0},null,null,null,null,null,null,null,0]
[null,null,null,"Sick write-off",892,{"$f":"IF(RIGHT(H9,3)=\"Yes\",H50*0.75,0)","v":0},0,0.01,null,null,null,null,null,null,null,0]
[null,null,null,"Sick write-off",892,0,0,-0.01,null,null,null,null,null,null,null,0]
[null,null,null,"Comp Payout",340,null,{"$f":"IF(B24<>\"\",G$15,)","v":0},{"$f":"IFERROR(IF(E24<>70,F24*G24,F24*G24*1.5),0)","v":0},null,null,null,null,null,null,null,0]
[null,"Employee DBA",null,"Amount","Detailed Reason for Interim:",null,null,null,null,null,null,null,null,null,null,0]
[null,"Pre-tax",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"(DBA#)","Retirement",{"$f":"IF(D9=\"Yes\",ROUND(D12*D4,2),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
[null,"(DBA#)","Medical",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"(DBA#)","Dental",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"(DBA#)","Vision",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"(DBA#)","Dependent Care",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"(DBA#)","Def. Comp",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"(DBA#)","Med Reimb",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"(DBA#)","HSA",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"(DBA#)","Parking / Bus Pass",null,"Date Interim Should Be Paid:",null,null,null,null,null,null,null,null,null,null,0]
[null,"(DBA#)","Other"]
[null,"Post-tax",null,null,"Please fill out the full form - once done click the button below to email a copy of this form to State Accounting.",null,null,null,null,"SCREENSHOT AREA"]
[null,"(DBA#)","Child Support"]
[null,"(DBA#)","Dependent Life"]
[null,"(DBA#)","AD&D"]
[null,"(DBA#)","STD"]
[null,"(DBA#)","LTD"]
[null,"(DBA#)","Optional Life"]
[null,"(DBA#)","Other"]
[null,"(DBA#)","Other"]
[null,"Employer DBA",null,"Amount","Vacation Hours",null,"Sick Hours"]
[null,"(DBA#)","Retirement match",{"$f":"ROUND(D27*D5,2)","v":0},"Begin Bal",null,"Begin Bal"]
[null,null,"Medical",null,"Used vac",{"$f":"SUM(SUMIF(E15:E22,ptVacation,F15:F22), SUMIF(M3:M35,ptVacation,N3:N35))","v":0},"Used sick",{"$f":"SUM(SUMIF(E15:E22,ptSick,F15:F22), SUMIF(M3:M35,ptSick,N3:N35))","v":0}]
[null,null,null,null,"Earned vac",{"$f":"D52","v":0},"Earned sick",{"$f":"D54","v":0}]
[null,null,null,null,"Total",{"$f":"F47-F48+F49","v":0},"Total",{"$f":"H47-H48+H49","v":0}]
[null,"Vacation, Sick, and Comp Earned",null,null,null,null,"Employee sick payout type:"]
[null,"(DBA#)","Vacation",null,"Comp Hours"]
[null,8600,"Vacation",{"$f":"D52","v":0},"Begin Bal"]
[null,"(DBA#)","Sick",null,"Comp Used",{"$f":"SUM(SUMIF(E15:E24,ptCompUsed,F15:F24), SUMIF(M3:M35,ptCompUsed,N3:N35))","v":0}]
[null,8601,"Sick",{"$f":"D54","v":0},"Comp Earned",{"$f":"D60","v":0}]
[null,8747,"Comp Earn @ 0.5",{"$f":"SUMIF($M$3:$M$35,87,$N$3:$N$35)","v":0},"Total",{"$f":"F53-F54+F55","v":0}]
[null,8750,"Comp Earn @ 1.0",{"$f":"SUMIF($M$3:$M$35,90,$N$3:$N$35)","v":0},"Authorization:"]
[null,8751,"Comp Earn @ 1.5",{"$f":"SUMIF($M$3:$M$35,91,$N$3:$N$35)","v":0}]
[null,8752,"Comp Earn @ 2.0",{"$f":"SUMIF($M$3:$M$35,92,$N$3:$N$35)","v":0}]
[null,8753,"Comp Earned",{"$f":"(D56*0.5)+D57+(D58*1.5)+(D59*2)","v":0}]
[]
[null,"Agency #                                     ",null,null,"Agency Name"]
[]
[null,"Agency Contact",null,null,"Phone #"]
[null,"Revised 3/2/2023"]

{"sheet":"Old W4 Calculation","index":1,"n_rows":87,"n_cols":27,"rows_kept":87,"cut":false,"hidden":false,"merged":[[17,9,17,10],[21,9,21,10],[5,1,5,2],[7,1,7,2],[9,1,9,2],[15,1,15,2],[21,1,21,2],[0,1,0,6],[39,4,39,6],[22,1,22,2],[31,1,31,2],[3,1,3,6],[1,2,1,5],[2,2,2,5],[22,4,22,6],[23,4,38,6]]}
[null,"2023 Payroll Calculation for 2023 - Rev 3/2/23",null,null,null,null,null,null,null,null,null,null,null,null,"Tax Tables",null,"DOCUMENTATION",null,null,null,null,null,"Retirement Percentage"]
[null,"Employee Name",{"$f":"Worksheet!D2","v":0},null,null,null,null,null,null,null,null,null,null,"Federal","Annual","Single",null,null,null,null,null,null,"Code","Percent"]
[null,"Address Book #",{"$f":"Worksheet!D3","v":0},null,null,null,null,null,null,null,null,null,null,0,0,0,"CELL ADDRESS","EXPLANATION",null,null,null,null,"J1",0.09]
[null,null,null,null,null,null,null,null,"m",null,null,null,null,5250,0,0.1,null,null,null,null,null,null,"J2",7.0000000000000007E-2]
[null,"Exemptions",{"$f":"Worksheet!H7","v":0},null,null,"Gross Wages",{"$f":"(C11*C12)+((C13*1.5)*C11)","v":0},null,{"$f":"IF((C7=I4),2,0)","v":0},null,null,"",null,16250,1100,0.12,"A5 thru B15","Basic information is entered in column B as directed in ",null,null,null,null,"J3",0.05]
[null,"Pay Cycle",null,null,null,"Federal Taxable Wages",{"$f":"G5-G13-G14-G16","v":0},null,"m",null,null,"",null,49975,5147,0.22,null,"column A.  This information is used to perform the needed",null,null,null,null,"J4",0.01]
[null,"B = Bi-weekly, M = Monthly",{"$f":"Worksheet!H3","v":"B"},null,null,"FICA Wages",{"$f":"G5-G16","v":0},null,{"$f":"IF((C9=I6),1,0)","v":0},null,null,"",null,100625,16290,0.24,null,"computations.",null,null,null,null,"J5",0.1]
[null,"Marital Status",null,null,null,"Retirement Wages",{"$f":"G5","v":0},null,{"$f":"I7","v":0},{"$f":"CHOOSE($I$8+1,N3,N15)","v":0},{"$f":"CHOOSE($I$8+1,N3,N15)","v":0},{"$f":"CHOOSE($I$8+1,O3,O15)","v":0},{"$f":"CHOOSE($I$8+1,P3,P15)","v":0},187350,37104,0.32,null,null,null,null,null,null,"P",0.16]
[null,"S = Single, M = Married",{"$f":"Worksheet!H5","v":"S"},null,null,"FIT",{"$f":"ROUND((((((I10-VLOOKUP(I10,J8:M17,2)))*VLOOKUP(I10,J8:M17,4))+VLOOKUP(I10,J8:M17,3))/I15)+C14,2)","v":0},null,{"$f":"O83/I15","v":165.38461538461539},{"$f":"CHOOSE($I$8+1,N4,N16)","v":5250},{"$f":"CHOOSE($I$8+1,N4,N16)","v":5250},{"$f":"CHOOSE($I$8+1,O4,O16)","v":0},{"$f":"CHOOSE($I$8+1,P4,P16)","v":0.1},236500,52832,0.35,"C7 thru F8","Retirement information is entered in columns D and F as ",null,null,null,null,"S",4.8000000000000001E-2]
[null,"Gross Wages",null,null,null,"SIT",{"$f":"ROUND((((((I45-VLOOKUP(I45,J40:M48,2)))*VLOOKUP(I45,J40:M48,4))+VLOOKUP(I45,J40:M48,3))/I47)+C15,2)","v":0},null,{"$f":"IF(I14<0,0,I16)","v":0},16250,16250,1100,0.12,583375,174238.25,0.37,null,"directed in columns C and E.  This identifies the amount",null,null,null,null,"T",9.7799999999999998E-2]
[null,"Rate per hour or total amount",{"$f":"Worksheet!D12","v":0},null,null,"Federal Soc Sec",{"$f":"ROUND(G$7*6.2/100,2)","v":0},null,"y",49975,49975,5147,0.22,9999999999,9999999999,1,null,"of wages which is not subject to taxes."]
[null,"Number of hours or 1 for total above",1,null,null,"Federal Medicare",{"$f":"ROUND(G$7*1.45/100,2)","v":0},null,{"$f":"IF(C17=I11,G13,0)","v":0},100625,100625,16290,0.24,9999999999,9999999999,1]
[null,"OT Hours or 0 if amount in total above",0,null,null,"Retirement",{"$f":"IF(C17=\"Y\",ROUND(G5*C20,2),0)","v":0},null,null,187350,187350,37104,0.32,null,null,null,"G4 thru G8","These cells compare entries for pay cycle and marital ",null,null,null,null,"State Percentages"]
[null,"Additional FIT",{"$f":"Worksheet!H11","v":0},null,null,"DCP",{"$f":"C21","v":0},null,{"$f":"G5-(I9*C5)-I12-G16-G14","v":0},236500,236500,52832,0.35,"Federal","Annual","Married","and","status to constants.  Based on the comparisons, different ",null,null,null,null,"Code","Percent",null,null,185]
[null,"Additional SIT",{"$f":"Worksheet!H12","v":0},null,null,"Post-Tax Deductions",{"$f":"SUM(C33:C40)","v":0},null,{"$f":"IF(C$7=\"b\",26,IF(C$7=\"M\",12,1))","v":26},583375,583375,174238.25,0.37,0,0,0,"G39 thru G45","values are placed in cell G8.  This value is used as ",null,null,null,null,"J1",0,null,null,90]
[null,"Retirement",null,null,null,"Pre-Tax Deductions",{"$f":"SUM(C24:C31)","v":0},null,{"$f":"I14*I15","v":0},9999999999,9999999999,9999999999,1,14800,0,0.1,null,"explained in the next group.",null,null,null,null,"J2",0]
[null,"(Y or N)",{"$f":"IF(rRetirement=\"Yes\",\"Y\",\"N\")","v":"Y"},null,null,"Net Take Home Pay ",{"$f":"G5-SUM(G9:G16)","v":0},null,null,9999999999,9999999999,9999999999,1,36800,2200,0.12,null,null,null,null,null,null,"J3",0]
[null,"S=State, T=Teacher, J=Judge, P=Patrol",null,null,null,null,null,null,null,"Minimum Wages Subject",null,null,null,104250,10294,0.22,"H8 thru K16","These cells use the value in G8 to select the correct",null,null,null,null,"J4",0]
[null,"Judges, J1=9%,J2=7%,J3=5%,J4=1%,J5=10%",{"$f":"Worksheet!D10","v":"S"},null,null,"State Contribution",null,null,null,"Biweekly",435,"Revised 8/24/09",null,205550,32580,0.24,"and","value from the four tables listed in L1 thru N37.",null,null,null,null,"J5",0]
[null,"% Withheld",{"$f":"IF(C19=\"S\",4.8%,IF(C19=\"J1\",9%,IF(C19=\"J2\",7%,IF(C19=\"J3\",5%,IF(C19=\"J4\",1%,IF(C19=\"J5\",10%,IF(C19=\"P\",16%,IF(C19=\"T\",9.78%,\"ERROR\"))))))))","v":4.8000000000000001E-2},null,null,"Federal Soc Sec",{"$f":"ROUND(G$7*6.2/100,2)","v":0},null,null,"Monthly",942.5,"Revised 8/24/09",null,379000,74208,0.32,"H40 thru k45",null,null,null,null,null,"P",1]
[null,"Deferred Comp  $ Withheld",{"$f":"Worksheet!D32","v":0},null,null,"Federal Medicare",{"$f":"ROUND(G$7*1.45/100,2)","v":0},null,null,null,null,null,null,477300,105664,0.35,"G9 and G44","This cell compares the pay cycle value to a standard to ",null,null,null,null,"S",1.56]
[null,"Deductions",null,null,null,"State Portion Retirement",{"$f":"+ROUND(G13*VLOOKUP(C19,W15:X22,2,0),2)","v":0},null,null,"Wage Range",null,null,null,708550,186601.5,0.37,null,"determine the proper amount to allow for each exemption.",null,null,null,null,"T",1.01]
[null,"Pre-Tax",null,null,"NOTES",null,null,788.97,null,"Biweekly",580,"Revised 8/24/09",null,9999999999,9999999999,1]
[null,"Health",{"$f":"Worksheet!D28","v":0},null,null,null,null,null,null,"Monthly",1256.6600000000001,"Revised 8/24/09",null,9999999999,9999999999,1,"G10 and G45","This cell computes taxable wages by taking total gross "]
[null,"Dental",{"$f":"Worksheet!D29","v":0},null,null,null,null,{"$f":"IF(G24-K19<=0,0,G24)","v":0},null,null,null,null,null,null,null,null,null,"less tax-sheltered retirement less the withholding amount "]
[null,"Vision",{"$f":"Worksheet!D30","v":0},null,null,null,null,{"$f":"IF(G24-K23>=0,0.25*G24,H25-K19)","v":-435},{"$f":"IF(H25<ABS(H26),H25,H26)","v":0},null,null,null,null,null,null,null,null,"times the number of exemptions."]
[null,"Dependent Care",{"$f":"Worksheet!D31","v":0},null,null,null,null,{"$f":"IF(G24-K23>=0,0.15*G24,H25-K19)","v":-435}]
[null,"Medical Reimbursment",{"$f":"Worksheet!D33","v":0},null,null,null,null,{"$f":"IF(G24-K23>=0,H25-K19,0.15*G24)","v":0},{"$f":"MIN(H25,H28,ABS(H27))","v":0},null,null,null,null,null,null,null,"G11 thru G12","These cells determine if the retirement is tax sheltered"]
[null,"Health Savings Account",{"$f":"Worksheet!D34","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"and then determines the amount for use in cell G10 & G45."]
[null,"Parking / Bus Pass",{"$f":"Worksheet!D35","v":0},null,null,null,null,{"$f":"IF(G24-K20<=0,0,G24)","v":0}]
[null,"Other",{"$f":"Worksheet!D36","v":0},null,null,null,null,{"$f":"IF(G24-K24>=0,0.25*G24,H30-K20)","v":-942.5},{"$f":"IF(H30<ABS(H31),H30,H31)","v":0},null,null,null,null,null,null,null,"E11","Comutes total gross by multiplying the values enter in"]
[null,"Post-Tax",null,null,null,null,null,{"$f":"IF(G24-K24>=0,0.15*G24,H30-K20)","v":-942.5},null,null,null,null,null,null,null,null,null,"column B."]
[null,"Child Support",{"$f":"Worksheet!D38","v":0},null,null,null,null,{"$f":"IF(G24-K24>=0,H30-K20,0.15*G24)","v":0},{"$f":"MIN(ABS(H32),H33,H30)","v":0}]
[null,"Dependent Life",{"$f":"Worksheet!D39","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"E14","Computes federal tax withholding by using the table "]
[null,"AD&D",{"$f":"Worksheet!D40","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"in cells H8 thru K16 and vlookup to identify the proper"]
[null,"STD",{"$f":"Worksheet!D41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"values to use in the formula."]
[null,"LTD",{"$f":"Worksheet!D42","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Protect the sheet when done."]
[null,"Optional Life",{"$f":"Worksheet!D43","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"E15","Computes state income tax withholding using cells H40 thru K45."]
[null,"Other",{"$f":"Worksheet!D44","v":0},null,null,null,null,null,"m",null,null,null,null,"State ","Annual","Single"]
[null,"Other",{"$f":"Worksheet!D45","v":0},null,"Revised 3/2/23",null,null,null,{"$f":"IF((C7=I39),2,0)","v":0},{"$f":"CHOOSE($I$43+1,N40,N50,N60,N70)","v":0},{"$f":"CHOOSE($I$43+1,N40,N50,N60,N70)","v":0},0,0,0,0,0,"E16","Computes social security using the standard percentage."]
[null,null,null,null,null,null,null,null,"m",{"$f":"CHOOSE($I$43+1,N41,N51,N61,N71)","v":3060},{"$f":"CHOOSE($I$43+1,N41,N51,N61,N71)","v":3060},{"$f":"CHOOSE($I$43+1,O41,O51,O61,O71)","v":0},{"$f":"CHOOSE($I$43+1,P41,P51,P61,P71)","v":2.2599999999999999E-2},3060,0,2.2599999999999999E-2]
[null,null,null,null,null,null,null,null,{"$f":"IF((C9=I41),1,0)","v":0},5990,5990,66.22,3.2199999999999999E-2,5990,66.22,3.2199999999999999E-2,"E17","Computes retirement by multiplying the gross by the "]
[null,null,null,null,null,null,null,null,{"$f":"I42","v":0},19470,19470,500.28,4.9099999999999998E-2,19470,500.28,4.9099999999999998E-2,null,"percentage entered and adding the fixed amount. "]
[null,null,null,null,null,null,null,null,{"$f":"O86/I47","v":82.307692307692307},28210,28210,929.41,6.2E-2,28210,929.41,6.2E-2]
[null,null,null,null,null,null,null,null,{"$f":"IF(I46<0,0,I48)","v":0},35820,35820,1401.23,6.3899999999999998E-2,35820,1401.23,6.3899999999999998E-2,"G23 thru H31","Computes the proper amount to hold for garnishment."]
[null,null,null,null,null,null,null,null,{"$f":"G5-(I44*C5)-I12-G16-G14","v":0},67270,67270,3410.89,6.7500000000000004E-2,67270,3410.89,6.7500000000000004E-2,null,"G23-H26 is for biweekly and G28-H31 is for monthly."]
[null,null,null,null,null,null,null,null,{"$f":"IF(C$7=\"b\",26,IF(C$7=\"m\",12,1))","v":26},999999999,999999999,999999999,1,999999999,999999999,1,"G23  G28","Compares disposable income to protected amount for the"]
[null,null,null,null,null,null,null,null,{"$f":"I46*I47","v":0},999999999,999999999,999999999,1,999999999,999999999,1,null,"pay period to see if any can be held."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"State","Annual","Married","G24  G29","Determines if 25% or amount exceeding protected amount "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,"should be held."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7530,0,2.2599999999999999E-2,"H24  H29","Selects the lessor of the above two amounts.  Non head of"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,11610,92.91,3.2199999999999999E-2,null,"household amount."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,28910,649.27,4.9099999999999998E-2,"G25  G30","Determines if 15% or amount exceeding protected amount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,44980,1438.31,6.2E-2,null,"should be held."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,55810,2109.77,6.3899999999999998E-2,"G26  G31","Determines if amount exceeding protected amount or 15%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,74010,3272.75,6.7500000000000004E-2,null,"should be held."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,999999999,999999999,1,"H26  H31","Select the lessor of the above two amounts and the G23/G28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,999999999,999999999,1,null,"amount.  Head of household amount."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The G25-G26/G30-G31 comparisons are necessary as the "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disposable Income approaches the break point, the 15%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"computaion will become lower than the difference which is"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"based on 25%."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E33","Selects the proper 15% amount depending upon the pay cycle."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E35","Selects the proper 25% amount depending upon the pay cycle."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H9","Uses values from B7 to determine the proper federal withholding"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," allowance amount obtained from cells N84 and N85."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H44","Uses values from B7 to determine the proper state withholding"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," allowance amount obtained from cells N87 and N88."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Withholding","Allowance"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Federal Annual",4300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Federal Monthly"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"State Annual",2140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"State Monthly"]

{"sheet":"New W4 Calculation","index":2,"n_rows":92,"n_cols":30,"rows_kept":92,"cut":false,"hidden":false,"merged":[[9,1,9,2],[11,1,11,2],[0,1,0,6],[22,9,22,10],[26,9,26,10],[3,1,3,6],[22,4,22,6],[23,4,43,6],[1,2,1,5],[2,2,2,5],[36,1,36,2],[26,1,26,2],[27,1,27,2],[20,1,20,2],[14,1,14,2]]}
[null,"2023 Payroll Calculation for 2023 - Rev 3/2/23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOCUMENTATION",null,null,null,null,null,"Retirement Percentage"]
[null,"Employee Name",{"$f":"Worksheet!D2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code","Percent"]
[null,"Address Book #",{"$f":"Worksheet!D3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"CELL ADDRESS","EXPLANATION",null,null,null,null,"J1",0.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J2",7.0000000000000007E-2]
[null,"State Exemptions",{"$f":"Worksheet!H7","v":0},null,null,"Gross Wages",{"$f":"(C16*C17)+((C18*1.5)*C16)","v":0},null,"m",null,null,null,null,null,null,null,"A5 thru B15","Basic information is entered in column B as directed in ",null,null,null,null,"J3",0.05,null,null,null,null,"Tax Tables"]
[null,"Multiple Job Flag (W-4 Step 2(c))",{"$f":"Worksheet!D6","v":"N"},null,null,"Federal Taxable Wages",{"$f":"G5-G13-G14-G16","v":0},null,{"$f":"IF((C11=I5),2,0)","v":0},null,null,"",null,null,"Tax Tables",null,null,null,null,null,null,null,null,null,null,null,null,"Federal","Annual","Single"]
[null,"Dependent credit - W4 line 3",{"$f":"Worksheet!D7","v":0},null,null,"FICA Wages",{"$f":"G5-G16","v":0},null,null,null,null,null,null,"Federal","Annual","Single",null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Other Income - W4 line 4a",{"$f":"Worksheet!D8","v":0},null,null,"Retirement Wages",{"$f":"G5","v":0},null,"j",null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,5250,0,0.1]
[null,"Other Deductions - W4 line 4b",{"$f":"Worksheet!H8","v":0},null,null,"FIT",{"$f":"I57-I58+C19","v":0},null,"a",null,null,null,null,6925,0,0.1,null,null,null,null,null,null,null,null,null,null,null,16250,1100,0.12]
[null,"Pay Cycle",null,null,null,"SIT",{"$f":"ROUND((((((I50-VLOOKUP(I50,J45:M53,2)))*VLOOKUP(I50,J45:M53,4))+VLOOKUP(I50,J45:M53,3))/I52)+C20,2)","v":0},null,"h",null,null,null,null,12425,550,0.12,null,"column A.  This information is used to perform the needed",null,null,null,null,"J4",0.01,null,null,null,49975,5147,0.22]
[null,"B = Bi-weekly, M = Monthly",{"$f":"Worksheet!H3","v":"B"},null,null,"Federal Soc Sec",{"$f":"ROUND(G$7*6.2/100,2)","v":0},null,"m",null,null,"",null,29288,2573.5,0.22,null,"computations.",null,null,null,null,"J5",0.1,null,null,null,100625,16290,0.24]
[null,"Marital Status",null,null,null,"Federal Medicare",{"$f":"ROUND(G$7*1.45/100,2)","v":0},null,{"$f":"IF(C14=I8,0,IF(C14=I9,1,2))","v":0},null,null,"",null,54613,8145,0.24,null,null,null,null,null,null,"P",0.16,null,null,null,187350,37104,0.32]
[null,"STATE S = Single, M = Married",{"$f":"Worksheet!H5","v":"S"},null,null,"Retirement",{"$f":"IF(C22=\"Y\",ROUND(G5*C25,2),0)","v":0},null,{"$f":"I12","v":0},{"$f":"IF($C$6=$I$16,CHOOSE($I$13+1,N8,N20,N32),CHOOSE($I$13+1,AB7,AB19,AB31))","v":0},{"$f":"IF($C$6=$I$16,CHOOSE($I$13+1,N8,N20,N32),CHOOSE($I$13+1,AB7,AB19,AB31))","v":0},{"$f":"IF($C$6=$I$16,CHOOSE($I$13+1,O8,O20,O32),CHOOSE($I$13+1,AC7,AC19,AC31))","v":0},{"$f":"IF($C$6=$I$16,CHOOSE($I$13+1,P8,P20,P32),CHOOSE($I$13+1,AD7,AD19,AD31))","v":0},97975,18552,0.32,"C7 thru F8","Retirement information is entered in columns D and F as ",null,null,null,null,"S",4.8000000000000001E-2,null,null,null,236500,52832,0.35]
[null,"FEDERAL J = Single, A = Married, H = HOH ",{"$f":"Worksheet!H6","v":"J"},null,null,"DCP",{"$f":"C26","v":0},null,{"$f":"IF(C14=I9,O88,P88)","v":8600},{"$f":"IF($C$6=$I$16,CHOOSE($I$13+1,N9,N21,N33),CHOOSE($I$13+1,AB8,AB20,AB32))","v":5250},5250,0,0.1,122550,26416,0.35,null,null,null,null,null,null,null,null,null,null,null,583375,174238.25,0.37]
[null,"Gross Wages",null,null,null,"Post-Tax Deductions",{"$f":"SUM(C38:C45)","v":0},null,{"$f":"IF(I19<0,0,I21)","v":0},16250,16250,1100,0.12,295988,87119.13,0.37,null,"directed in columns C and E.  This identifies the amount",null,null,null,null,"T",9.7799999999999998E-2,null,null,null,9999999999,9999999999,1]
[null,"Rate per hour or total amount",{"$f":"Worksheet!D12","v":0},null,null,"Pre-Tax Deductions",{"$f":"SUM(C29:C36)","v":0},null,"y",49975,49975,5147,0.22,9999999999,9999999999,1,null,"of wages which is not subject to taxes.",null,null,null,null,null,null,null,null,null,9999999999,9999999999,1]
[null,"Number of hours or 1 for total above",1,null,null,"Net Take Home Pay ",{"$f":"G5-SUM(G9:G16)","v":0},null,{"$f":"IF(C22=I16,G13,0)","v":0},100625,{"$f":"IF($C$6=$I$16,CHOOSE($I$13+1,N12,N24,N36),CHOOSE($I$13+1,AB11,AB23,AB35))","v":100625},16290,0.24,9999999999,9999999999,1]
[null,"OT Hours or 0 if amount in total above",0,null,null,null,null,null,null,187350,187350,37104,0.32,null,null,null,"G4 thru G8","These cells compare entries for pay cycle and marital ",null,null,null,null,"State Percentages",null,null,null,null,"Federal","Annual","Married"]
[null,"Additional FIT",{"$f":"Worksheet!H11","v":0},null,null,"State Contribution",null,null,{"$f":"G5-I17-G16-G14-IF(C6=I16,0,I14/I20)","v":-330.76923076923077},236500,236500,52832,0.35,"Federal","Annual","Married","and","status to constants.  Based on the comparisons, different ",null,null,null,null,"Code","Percent",null,null,185,0,0,0]
[null,"Additional SIT",{"$f":"Worksheet!H12","v":0},null,null,"Federal Soc Sec",{"$f":"ROUND(G$7*6.2/100,2)","v":0},null,{"$f":"IF(C$11=\"b\",26,IF(C$11=\"M\",12,1))","v":26},583375,583375,174238.25,0.37,0,0,0,"G39 thru G45","values are placed in cell G8.  This value is used as ",null,null,null,null,"J1",0,null,null,90,14800,0,0.1]
[null,"Retirement",null,null,null,"Federal Medicare",{"$f":"ROUND(G$7*1.45/100,2)","v":0},null,{"$f":"(I19*I20)+C8-C9","v":-8600},9999999999,9999999999,9999999999,1,13850,0,0.1,null,"explained in the next group.",null,null,null,null,"J2",0,null,null,null,36800,2200,0.12]
[null,"(Y or N)",{"$f":"IF(rRetirement=\"Yes\",\"Y\",\"N\")","v":"Y"},null,null,"State Portion Retirement",{"$f":"+ROUND(G13*VLOOKUP(C24,W20:X27,2,0),2)","v":0},null,null,9999999999,9999999999,9999999999,1,24850,1100,0.12,null,null,null,null,null,null,"J3",0,null,null,null,104250,10294,0.22]
[null,"S = State, T = Teacher, J = Judge, P = Patrol"," ",null,"NOTES",null,null,null,null,"Minimum Wages Subject",null,null,null,58575,5147,0.22,"H8 thru K16","These cells use the value in G8 to select the correct",null,null,null,null,"J4",0,null,null,null,205550,32580,0.24]
[null,"Judges : J1 = 9%, J2 = 7%, J3 = 5%, J4 = 1%, J5 = 10%",{"$f":"Worksheet!D10","v":"S"},null,null,null,null,null,null,"Biweekly",435,"Revised 8/24/09",null,109225,16290,0.24,"and","value from the four tables listed in L1 thru N37.",null,null,null,null,"J5",0,null,null,null,379000,74208,0.32]
[null,"% Withheld",{"$f":"IF(C24=\"S\",4.8%,IF(C24=\"J1\",9%,IF(C24=\"J2\",7%,IF(C24=\"J3\",5%,IF(C24=\"J4\",1%,IF(C24=\"J5\",10%,IF(C24=\"P\",16%,IF(C24=\"T\",9.78%,\"ERROR\"))))))))","v":4.8000000000000001E-2},null,null,null,null,null,null,"Monthly",942.5,"Revised 8/24/09",null,195950,37104,0.32,"H40 thru k45",null,null,null,null,null,"P",1,null,null,null,477300,105664,0.35]
[null,"Deferred Comp  $ Withheld",{"$f":"Worksheet!D32","v":0},null,null,null,null,null,null,null,null,null,null,245100,52832,0.35,"G9 and G44","This cell compares the pay cycle value to a standard to ",null,null,null,null,"S",1.56,null,null,null,708550,186601.5,0.37]
[null,"Deductions",null,null,null,null,null,null,null,"Wage Range",null,null,null,360725,93300.75,0.37,null,"determine the proper amount to allow for each exemption.",null,null,null,null,"T",1.01,null,null,null,9999999999,9999999999,1]
[null,"Pre-Tax",null,null,null,null,null,788.97,null,"Biweekly",580,"Revised 8/24/09",null,9999999999,9999999999,1,null,null,null,null,null,null,null,null,null,null,null,9999999999,9999999999,1]
[null,"Health",{"$f":"Worksheet!D28","v":0},null,null,null,null,null,null,"Monthly",1256.6600000000001,"Revised 8/24/09",null,9999999999,9999999999,1,"G10 and G45","This cell computes taxable wages by taking total gross "]
[null,"Dental",{"$f":"Worksheet!D29","v":0},null,null,null,null,{"$f":"IF(G29-K24<=0,0,G29)","v":0},null,null,null,null,null,null,null,null,null,"less tax-sheltered retirement less the withholding amount ",null,null,null,null,null,null,null,null,null,"Federal","Annual","HOH"]
[null,"Vision",{"$f":"Worksheet!D30","v":0},null,null,null,null,{"$f":"IF(G29-K28>=0,0.25*G29,H30-K24)","v":-435},{"$f":"IF(H30<ABS(H31),H30,H31)","v":0},null,null,null,null,"Federal","Annual","HOH",null,"times the number of exemptions.",null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Dependent Care",{"$f":"Worksheet!D31","v":0},null,null,null,null,{"$f":"IF(G29-K28>=0,0.15*G29,H30-K24)","v":-435},null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,12200,0,0.1]
[null,"Medical Reimbursment",{"$f":"Worksheet!D33","v":0},null,null,null,null,{"$f":"IF(G29-K28>=0,H30-K24,0.15*G29)","v":0},{"$f":"MIN(H30,H33,ABS(H32))","v":0},null,null,null,null,10400,0,0.1,"G11 thru G12","These cells determine if the retirement is tax sheltered",null,null,null,null,null,null,null,null,null,27900,1570,0.12]
[null,"Health Savings Account",{"$f":"Worksheet!D34","v":0},null,null,null,null,null,null,null,null,null,null,18250,785,0.12,null,"and then determines the amount for use in cell G10 & G45.",null,null,null,null,null,null,null,null,null,72050,6868,0.22]
[null,"Parking / Bus Pass",{"$f":"Worksheet!D35","v":0},null,null,null,null,{"$f":"IF(G29-K25<=0,0,G29)","v":0},null,null,null,null,null,40325,3434,0.22,null,null,null,null,null,null,null,null,null,null,null,107550,14678,0.24]
[null,"Other",{"$f":"Worksheet!D36","v":0},null,null,null,null,{"$f":"IF(G29-K29>=0,0.25*G29,H35-K25)","v":-942.5},{"$f":"IF(H35<ABS(H36),H35,H36)","v":0},null,null,null,null,58075,7339,0.24,"E11","Comutes total gross by multiplying the values enter in",null,null,null,null,null,null,null,null,null,194300,35498,0.32]
[null,"Post-Tax",null,null,null,null,null,{"$f":"IF(G29-K29>=0,0.15*G29,H35-K25)","v":-942.5},null,null,null,null,null,101450,17749,0.32,null,"column B.",null,null,null,null,null,null,null,null,null,243450,51226,0.35]
[null,"Child Support",{"$f":"Worksheet!D38","v":0},null,null,null,null,{"$f":"IF(G29-K29>=0,H35-K25,0.15*G29)","v":0},{"$f":"MIN(ABS(H37),H38,H35)","v":0},null,null,null,null,126025,25613,0.35,null,null,null,null,null,null,null,null,null,null,null,590300,172623.5,0.37]
[null,"Dependent Life",{"$f":"Worksheet!D39","v":0},null,null,null,null,null,null,null,null,null,null,299450,86311.75,0.37,"E14","Computes federal tax withholding by using the table ",null,null,null,null,null,null,null,null,null,9999999999,9999999999,1]
[null,"AD&D",{"$f":"Worksheet!D40","v":0},null,null,null,null,null,null,null,null,null,null,9999999999,9999999999,1,null,"in cells H8 thru K16 and vlookup to identify the proper",null,null,null,null,null,null,null,null,null,9999999999,9999999999,1]
[null,"STD",{"$f":"Worksheet!D41","v":0},null,null,null,null,null,null,null,null,null,null,9999999999,9999999999,1,null,"values to use in the formula."]
[null,"LTD",{"$f":"Worksheet!D42","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Protect the sheet when done."]
[null,"Optional Life",{"$f":"Worksheet!D43","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"E15","Computes state income tax withholding using cells H40 thru K45."]
[null,"Other",{"$f":"Worksheet!D44","v":0},null,null,null,null,null,"m",null,null,null,null,"State ","Annual","Single"]
[null,"Other",{"$f":"Worksheet!D45","v":0},null,null,null,"Revised 3/2/23",null,{"$f":"IF((C11=I44),2,0)","v":0},{"$f":"CHOOSE($I$48+1,N45,N55,N65,N75)","v":0},{"$f":"CHOOSE($I$48+1,N45,N55,N65,N75)","v":0},0,0,0,0,0,"E16","Computes social security using the standard percentage."]
[null,null,null,null,null,null,null,null,"m",{"$f":"CHOOSE($I$48+1,N46,N56,N66,N76)","v":3060},{"$f":"CHOOSE($I$48+1,N46,N56,N66,N76)","v":3060},{"$f":"CHOOSE($I$48+1,O46,O56,O66,O76)","v":0},{"$f":"CHOOSE($I$48+1,P46,P56,P66,P76)","v":2.2599999999999999E-2},3060,0,2.2599999999999999E-2]
[null,null,null,null,null,null,null,null,{"$f":"IF((C13=I46),1,0)","v":0},5990,5990,66.22,3.2199999999999999E-2,5990,66.22,3.2199999999999999E-2,"E17","Computes retirement by multiplying the gross by the "]
[null,null,null,null,null,null,null,null,{"$f":"I47","v":0},19470,19470,500.28,4.9099999999999998E-2,19470,500.28,4.9099999999999998E-2,null,"percentage entered and adding the fixed amount. "]
[null,null,null,null,null,null,null,null,{"$f":"O91/I52","v":82.307692307692307},28210,28210,929.41,6.2E-2,28210,929.41,6.2E-2]
[null,null,null,null,null,null,null,null,{"$f":"IF(I51<0,0,I53)","v":0},35820,35820,1401.23,6.3899999999999998E-2,35820,1401.23,6.3899999999999998E-2,"G23 thru H31","Computes the proper amount to hold for garnishment."]
[null,null,null,null,null,null,null,null,{"$f":"G5-(I49*C5)-I17-G16-G14","v":0},67270,67270,3410.89,6.7500000000000004E-2,67270,3410.89,6.7500000000000004E-2,null,"G23-H26 is for biweekly and G28-H31 is for monthly."]
[null,null,null,null,null,null,null,null,{"$f":"IF(C$11=\"b\",26,IF(C$11=\"m\",12,1))","v":26},999999999,999999999,999999999,1,999999999,999999999,1,"G23  G28","Compares disposable income to protected amount for the"]
[null,null,null,null,null,null,null,null,{"$f":"I51*I52","v":0},999999999,999999999,999999999,1,999999999,999999999,1,null,"pay period to see if any can be held."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"State","Annual","Married","G24  G29","Determines if 25% or amount exceeding protected amount "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,"should be held."]
[null,null,null,null,null,null,null,null,{"$f":"C7/I20","v":0},null,null,null,null,7530,0,2.2599999999999999E-2,"H24  H29","Selects the lessor of the above two amounts.  Non head of"]
[null,null,null,null,null,null,null,null,{"$f":"ROUND((((((I15-VLOOKUP(I15,J13:M22,2)))*VLOOKUP(I15,J13:M22,4))+VLOOKUP(I15,J13:M22,3))/I20),2)","v":0},null,null,null,null,11610,92.91,3.2199999999999999E-2,null,"household amount."]
[null,null,null,null,null,null,null,null,{"$f":"IF(I57>I56,I56,I57)","v":0},null,null,null,null,28910,649.27,4.9099999999999998E-2,"G25  G30","Determines if 15% or amount exceeding protected amount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,44980,1438.31,6.2E-2,null,"should be held."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,55810,2109.77,6.3899999999999998E-2,"G26  G31","Determines if amount exceeding protected amount or 15%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,74010,3272.75,6.7500000000000004E-2,null,"should be held."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,999999999,999999999,1,"H26  H31","Select the lessor of the above two amounts and the G23/G28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,999999999,999999999,1,null,"amount.  Head of household amount."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The G25-G26/G30-G31 comparisons are necessary as the "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disposable Income approaches the break point, the 15%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"computaion will become lower than the difference which is"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"based on 25%."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E33","Selects the proper 15% amount depending upon the pay cycle."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E35","Selects the proper 25% amount depending upon the pay cycle."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H9","Uses values from B7 to determine the proper federal withholding"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," allowance amount obtained from cells N84 and N85."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H44","Uses values from B7 to determine the proper state withholding"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," allowance amount obtained from cells N87 and N88."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Withholding","Allowance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maried","Single/HOH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Federal Annual",12900,8600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Federal Monthly"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"State Annual",2140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"State Monthly"]

{"sheet":"Speedtime","index":3,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["Pay DBA",null,"Hours","Account #",null,"LS Amount","Rate"]
[{"$f":"Worksheet!E15","v":1},null,{"$f":"Worksheet!F15","v":0},{"$f":"Worksheet!B15","v":0},null,null,{"$f":"Worksheet!G15","v":0}]
[{"$f":"Worksheet!E16","v":2},null,{"$f":"Worksheet!F16","v":0},{"$f":"Worksheet!B16","v":0},null,null,{"$f":"Worksheet!G16","v":0}]
[{"$f":"Worksheet!E17","v":30},null,{"$f":"Worksheet!F17","v":0},{"$f":"Worksheet!B17","v":0},null,null,{"$f":"Worksheet!G17","v":0}]
[{"$f":"Worksheet!E18","v":40},null,{"$f":"Worksheet!F18","v":0},{"$f":"Worksheet!B18","v":0},null,null,{"$f":"Worksheet!G18","v":0}]
[{"$f":"Worksheet!E19","v":240},null,{"$f":"Worksheet!F19","v":0},{"$f":"Worksheet!B19","v":0},null,null,{"$f":"Worksheet!G19","v":0}]
[{"$f":"Worksheet!E20","v":330},null,{"$f":"Worksheet!F20","v":0},{"$f":"Worksheet!B20","v":0},null,null,{"$f":"Worksheet!G20","v":0}]
[{"$f":"Worksheet!E21","v":320},null,{"$f":"Worksheet!F21","v":"Not applicable"},{"$f":"Worksheet!B21","v":0},null,null,{"$f":"Worksheet!G21","v":0}]
[{"$f":"Worksheet!E22","v":892},null,{"$f":"Worksheet!F22","v":0},{"$f":"Worksheet!B22","v":0},null,null,{"$f":"Worksheet!G22","v":0}]
[{"$f":"Worksheet!E23","v":892},null,{"$f":"Worksheet!F23","v":0},{"$f":"Worksheet!B23","v":0},null,null,{"$f":"Worksheet!G23","v":0}]
[{"$f":"Worksheet!E24","v":340},null,{"$f":"Worksheet!F24","v":0},{"$f":"Worksheet!B24","v":0},null,null,{"$f":"Worksheet!G24","v":0}]
[{"$f":"Worksheet!M3","v":0},null,{"$f":"Worksheet!N3","v":0},{"$f":"Worksheet!J3","v":0},null,null,{"$f":"Worksheet!O3","v":0}]
[{"$f":"Worksheet!M4","v":0},null,{"$f":"Worksheet!N4","v":0},{"$f":"Worksheet!J4","v":0},null,null,{"$f":"Worksheet!O4","v":0}]
[{"$f":"Worksheet!M5","v":0},null,{"$f":"Worksheet!N5","v":0},{"$f":"Worksheet!J5","v":0},null,null,{"$f":"Worksheet!O5","v":0}]
[{"$f":"Worksheet!M6","v":0},null,{"$f":"Worksheet!N6","v":0},{"$f":"Worksheet!J6","v":0},null,null,{"$f":"Worksheet!O6","v":0}]
[{"$f":"Worksheet!M7","v":0},null,{"$f":"Worksheet!N7","v":0},{"$f":"Worksheet!J7","v":0},null,null,{"$f":"Worksheet!O7","v":0}]
[{"$f":"Worksheet!M8","v":0},null,{"$f":"Worksheet!N8","v":0},{"$f":"Worksheet!J8","v":0},null,null,{"$f":"Worksheet!O8","v":0}]
[{"$f":"Worksheet!M9","v":0},null,{"$f":"Worksheet!N9","v":0},{"$f":"Worksheet!J9","v":0},null,null,{"$f":"Worksheet!O9","v":0}]
[{"$f":"Worksheet!M10","v":0},null,{"$f":"Worksheet!N10","v":0},{"$f":"Worksheet!J10","v":0},null,null,{"$f":"Worksheet!O10","v":0}]
[{"$f":"Worksheet!M11","v":0},null,{"$f":"Worksheet!N11","v":0},{"$f":"Worksheet!J11","v":0},null,null,{"$f":"Worksheet!O11","v":0}]
[{"$f":"Worksheet!M12","v":0},null,{"$f":"Worksheet!N12","v":0},{"$f":"Worksheet!J12","v":0},null,null,{"$f":"Worksheet!O12","v":0}]
[{"$f":"Worksheet!M13","v":0},null,{"$f":"Worksheet!N13","v":0},{"$f":"Worksheet!J13","v":0},null,null,{"$f":"Worksheet!O13","v":0}]
[{"$f":"Worksheet!M14","v":0},null,{"$f":"Worksheet!N14","v":0},{"$f":"Worksheet!J14","v":0},null,null,{"$f":"Worksheet!O14","v":0}]
[{"$f":"Worksheet!M15","v":0},null,{"$f":"Worksheet!N15","v":0},{"$f":"Worksheet!J15","v":0},null,null,{"$f":"Worksheet!O15","v":0}]
[{"$f":"Worksheet!M16","v":0},null,{"$f":"Worksheet!N16","v":0},{"$f":"Worksheet!J16","v":0},null,null,{"$f":"Worksheet!O16","v":0}]
[{"$f":"Worksheet!M17","v":0},null,{"$f":"Worksheet!N17","v":0},{"$f":"Worksheet!J17","v":0},null,null,{"$f":"Worksheet!O17","v":0}]
[{"$f":"Worksheet!M18","v":0},null,{"$f":"Worksheet!N18","v":0},{"$f":"Worksheet!J18","v":0},null,null,{"$f":"Worksheet!O18","v":0}]
[{"$f":"Worksheet!M19","v":0},null,{"$f":"Worksheet!N19","v":0},{"$f":"Worksheet!J19","v":0},null,null,{"$f":"Worksheet!O19","v":0}]
[{"$f":"Worksheet!M20","v":0},null,{"$f":"Worksheet!N20","v":0},{"$f":"Worksheet!J20","v":0},null,null,{"$f":"Worksheet!O20","v":0}]
[{"$f":"Worksheet!M21","v":0},null,{"$f":"Worksheet!N21","v":0},{"$f":"Worksheet!J21","v":0},null,null,{"$f":"Worksheet!O21","v":0}]
[{"$f":"Worksheet!M22","v":0},null,{"$f":"Worksheet!N22","v":0},{"$f":"Worksheet!J22","v":0},null,null,{"$f":"Worksheet!O22","v":0}]
[{"$f":"Worksheet!M23","v":0},null,{"$f":"Worksheet!N23","v":0},{"$f":"Worksheet!J23","v":0},null,null,{"$f":"Worksheet!O23","v":0}]
[{"$f":"Worksheet!M24","v":0},null,{"$f":"Worksheet!N24","v":0},{"$f":"Worksheet!J24","v":0},null,null,{"$f":"Worksheet!O24","v":0}]
[{"$f":"Worksheet!M25","v":0},null,{"$f":"Worksheet!N25","v":0},{"$f":"Worksheet!J25","v":0},null,null,{"$f":"Worksheet!O25","v":0}]
[{"$f":"Worksheet!M26","v":0},null,{"$f":"Worksheet!N26","v":0},{"$f":"Worksheet!J26","v":0},null,null,{"$f":"Worksheet!O26","v":0}]
[{"$f":"Worksheet!M27","v":0},null,{"$f":"Worksheet!N27","v":0},{"$f":"Worksheet!J27","v":0},null,null,{"$f":"Worksheet!O27","v":0}]
[{"$f":"Worksheet!M28","v":0},null,{"$f":"Worksheet!N28","v":0},{"$f":"Worksheet!J28","v":0},null,null,{"$f":"Worksheet!O28","v":0}]
[{"$f":"Worksheet!M29","v":0},null,{"$f":"Worksheet!N29","v":0},{"$f":"Worksheet!J29","v":0},null,null,{"$f":"Worksheet!O29","v":0}]
[{"$f":"Worksheet!M30","v":0},null,{"$f":"Worksheet!N30","v":0},{"$f":"Worksheet!J30","v":0},null,null,{"$f":"Worksheet!O30","v":0}]
[{"$f":"Worksheet!M31","v":0},null,{"$f":"Worksheet!N31","v":0},{"$f":"Worksheet!J31","v":0},null,null,{"$f":"Worksheet!O31","v":0}]
[{"$f":"Worksheet!M32","v":0},null,{"$f":"Worksheet!N32","v":0},{"$f":"Worksheet!J32","v":0},null,null,{"$f":"Worksheet!O32","v":0}]

{"sheet":"OTO Upload","index":4,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["DBA #","Amt","Basis"]
[{"$f":"Worksheet!B27","v":"(DBA#)"},{"$f":"Worksheet!D27","v":0}]
[{"$f":"Worksheet!B28","v":"(DBA#)"},{"$f":"Worksheet!D28","v":0}]
[{"$f":"Worksheet!B29","v":"(DBA#)"},{"$f":"Worksheet!D29","v":0}]
[{"$f":"Worksheet!B30","v":"(DBA#)"},{"$f":"Worksheet!D30","v":0}]
[{"$f":"Worksheet!B31","v":"(DBA#)"},{"$f":"Worksheet!D31","v":0}]
[{"$f":"Worksheet!B32","v":"(DBA#)"},{"$f":"Worksheet!D32","v":0}]
[{"$f":"Worksheet!B33","v":"(DBA#)"},{"$f":"Worksheet!D33","v":0}]
[{"$f":"Worksheet!B34","v":"(DBA#)"},{"$f":"Worksheet!D34","v":0}]
[{"$f":"Worksheet!B35","v":"(DBA#)"},{"$f":"Worksheet!D35","v":0}]
[{"$f":"Worksheet!B36","v":"(DBA#)"},{"$f":"Worksheet!D36","v":0}]
[null,{"$f":"Worksheet!D37","v":0}]
[{"$f":"Worksheet!B38","v":"(DBA#)"},{"$f":"Worksheet!D38","v":0}]
[{"$f":"Worksheet!B39","v":"(DBA#)"},{"$f":"Worksheet!D39","v":0}]
[{"$f":"Worksheet!B40","v":"(DBA#)"},{"$f":"Worksheet!D40","v":0}]
[{"$f":"Worksheet!B41","v":"(DBA#)"},{"$f":"Worksheet!D41","v":0}]
[{"$f":"Worksheet!B42","v":"(DBA#)"},{"$f":"Worksheet!D42","v":0}]
[{"$f":"Worksheet!B43","v":"(DBA#)"},{"$f":"Worksheet!D43","v":0}]
[{"$f":"Worksheet!B44","v":"(DBA#)"},{"$f":"Worksheet!D44","v":0}]
[{"$f":"Worksheet!B45","v":"(DBA#)"},{"$f":"Worksheet!D45","v":0}]
[]
[{"$f":"Worksheet!B47","v":"(DBA#)"},{"$f":"Worksheet!D47","v":0}]
[{"$f":"Worksheet!B48","v":0},{"$f":"Worksheet!D48","v":0}]
[{"$f":"Worksheet!B49","v":0},{"$f":"Worksheet!D49","v":0}]
[{"$f":"Worksheet!B50","v":0},{"$f":"Worksheet!D50","v":0}]
[null,{"$f":"Worksheet!D51","v":0}]
[{"$f":"Worksheet!B52","v":"(DBA#)"},{"$f":"Worksheet!D52","v":0},{"$f":"Worksheet!D52","v":0}]
[{"$f":"Worksheet!B53","v":8600},{"$f":"Worksheet!D53","v":0},{"$f":"Worksheet!D53","v":0}]
[{"$f":"Worksheet!B54","v":"(DBA#)"},{"$f":"Worksheet!D54","v":0},{"$f":"Worksheet!D54","v":0}]
[{"$f":"Worksheet!B55","v":8601},{"$f":"Worksheet!D55","v":0},{"$f":"Worksheet!D55","v":0}]
[{"$f":"Worksheet!B56","v":8747},{"$f":"Worksheet!D56","v":0},{"$f":"Worksheet!D56","v":0}]
[{"$f":"Worksheet!B57","v":8750},{"$f":"Worksheet!D57","v":0},{"$f":"Worksheet!D57","v":0}]
[{"$f":"Worksheet!B58","v":8751},{"$f":"Worksheet!D58","v":0},{"$f":"Worksheet!D58","v":0}]
[{"$f":"Worksheet!B59","v":8752},{"$f":"Worksheet!D59","v":0},{"$f":"Worksheet!D59","v":0}]
[{"$f":"Worksheet!B60","v":8753},{"$f":"Worksheet!D60","v":0},{"$f":"Worksheet!D60","v":0}]

{"sheet":"Data","index":5,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Screenshot help","First, take a screenshot of your DBA screen in E1 - an easy way to do this is with the snipping tool.\n\nTo open the snipping tool, press the start button and type in \"snipping\" - the snipping tool option should show up, click on it to open it.\n\nNext, click the \"New\" button on the snipping tool window.  Drag a window around your DBA screen in the PFC - the snipping tool will show the screenshot.  Press ctrl+C to copy it, or go to the Edit menu in the snipping tool and choose Copy.\n\nFinally, come back to the spreadsheet and click the Paste Picture button to insert the image into the screenshot area.","LISTS >>>","Sick Pay Types","Vacation Pay Types","Comp Used Pay Types"]
["Account help","Enter any necessary account numbers into the appropriate pay types below along with rate and hours below, add any additional accounts and pay types to the right.\n\nThe Overtime 1.5x pay type calculates the .5 increase into the sum; enter the normal non-overtime rate.\n\nIf a pay type is not needed, leave the account/hours/rate columns blank.  If the same pay type is needed for mutple accounts, enter the additional accounts to the right.","<<< TEXT/VARS",40,30,50]
["Add. account help","Enter any additional accounts and pay types below, along with the hours and rate.  Overtime 1.5x rates are calculated automatically in the total, so enter the normal rate.",null,41,31,340]
["Main area help","Fill out the requested information on this form - anything highlighted in red is required, anything in blue is a calculated or static value and does not need to be filled out, and anything in green should be filled out if appropriate.  For items with a yes/no response, you can either select yes/no from the drop down menu or type in yes or no.\n\nThere are [?] help buttons in the upper-left of some sections; click on them for additional information in that area.\n\nAfter filling out the form, take a screenshot of the DBA page in E1 and attach it to this spreadsheet using the Screenshot area in the bottom right - see that area for additional help on this.",null,180,252,52]
["Employee DBA","Enter any needed DBA codes for Retirement/Medical/Dental/Vision - Retirement calculates automatically, enter amounts for the rest.  Any additional DBA codes and amounts can be added underneath vision (only the code # is needed).\n\nNote that pre-tax DBAs are entered on the top, and post-tax underneath in the Post Tax section.",null,251,330,343]
["Employer DBA","Enter DBA code for retirement and medical if necessary - the retirement amount is calculated automatically.  Additional DBA codes can be entered underneath the medical one.\n\nBelow the employer DBA codes enter in any earned sick or vacation time.",null,890,331]
["Revision date","12/28/2021",null,null,882]
["Vacation, Sick, and Comp Earned","Regarding Comp Earned Accruals : The figures will need to be added here in correspondence with any comp accrual pay types.",null,null,888]
["Sick payout max",{"$f":"IF(Worksheet!H51=\"SCATA\",360,IF(Worksheet!H51=\"NAPE or FOP\",480,IF(OR(Worksheet!H51=\"Rules\",Worksheet!H51=\"Non-contract\"),1440,IF(Worksheet!H51=\"SLEBC\",400,400))))","v":400},null,null,894]
["Sick payout warn",{"$f":"B9","v":400},null,0,0]
["Sick warning msg","WARNING: The Sick Payout is at or exceeds the max hours; please verify this does not go over the limit:\n\nNAPE AND FOP Employees: One quarter of balance, no more than 480 hours\n\nSCATA Teachers: One quarter of balance, no more than 360 hours\n\nSLEBC Employees: One quarter of balance, no more than 400 hours\n\nRules and other non-contract employees: One quarter of balance, no more than 1440 hours plus one quarter of hours accumlated during year of retirement"]
["Sick warning shown",false]
["Email address","as.stateaccountingpayroll@nebraska.gov"]
["Email subject","Interim Payroll Form"]
["Email text","Add any additional notes here if needed"]